package com.zzedu.mapper;

import java.util.List;

import com.zzedu.domain.ZzSchool;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 * 学校管理Mapper接口
 *
 * @author Mr.Wang
 * @date 2025-01-27
 */
public interface ZzSchoolMapper extends BaseMapper<ZzSchool> {

    @Select({"<script>", "select ifnull(sum(ifnull(student_capacity,0)),0) from zz_school where org_id=#{orgId}", "</script>"})
    Long sumCount(Long orgId);
}
